<?php include './funtion.php';?>
<link href="style.css" rel="stylesheet" type="text/css"/>
<html>
    <head>
        
    </head>
    <body>
        <div id="wrapper">
        <?php
            $sql= 'select* from students;';
            $student= query($sql);
            //var_dump($student);
        ?>
        <h3>Bang Sinh Vien</h3>
        <table border="1">
             <tr>
                <td>ID</td>
                <td>Name</td>
            </tr>
            <?php
                    foreach ($student as $students):
            ?>
           
            <tr>
                <td>
                    <?php echo ($students['id']); ?>
                </td>
                 <td>
                    <?php echo ($students['name']); ?>
                </td>
            </tr>
            
            <?php            endforeach;?>
            
        </table>
        <input type="text" value="nhap">
            <input type="submit" value="sua">
        
        <?php
            $sql= 'select* from staffs;';
            $staff= query($sql);
            //var_dump($staff);
        ?>
             <h3>Bang Nhan Vien</h3>
        <table border="1">
             <tr>
                <td>ID</td>
                <td>Name</td>
                
            </tr>
            <?php
                    foreach ($staff as $staffs):
            ?>
           
            <tr>
                <td>
                    <?php echo ($staffs['id']); ?>
                </td>
                 <td>
                    <?php echo ($staffs['name']); ?>
                </td>
               
            </tr>
            <?php            endforeach;?>
        </table>
              <input type="text" value="nhap">
            <input type="submit" value="sua">
        </div>
    </body>
</html>


